calculated date column returns the wrong day

=TEXT([Start Time],"ddd, dd MMMM")

is off by one day. why? it's an all day event in a standard calendar.
sullisnyc44Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
sullisnyc44Connect With a Mentor Author Commented:
you need to do this:


=TEXT(IF(TEXT([End Time]-[Start Time],"h:mm")="23:59",[Start Time]+1,[Start Time]),"ddd, dd MMMM")
0
 
wshark83Commented:
works fine for me...is the [Start Time] formatted as date?

I've tried the following:

24 March 2012      Sat, 24 March
24/03/2012 00:00      Sat, 24 March
24/03/2012      Sat, 24 March

25 March 2012      Sun, 25 March
25/03/2012 00:00      Sun, 25 March
25/03/2012      Sun, 25 March

26 March 2012      Mon, 26 March
26/03/2012 00:00      Mon, 26 March
26/03/2012      Mon, 26 March
0
 
dhawalsethCommented:
Hi,
Use excel functions, e.g. if you have the datetime column use the following code to return date as string
column name= 'Date of Birth'
calculated column formula = YEAR(DateOfBirth)&"-"&DAY(DateOfBirth)&"-"&MONTH(DateOfBirth)
0
 
sullisnyc44Author Commented:
this works
0
All Courses

From novice to tech pro — start learning today.