| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to record the date
Hi,
I've been working with the following formula: IF(B2<time(14,0,0),today()+1, today()). What the formula should do is determine if it is before 2pm on a given day then put today's day. If it's after 2pm then put tomorrow's date. I have formatted cell B2 to state =Now(). Unfortunately, it's not working and I always get tomorrow's date. Any ideas how I can fix this to make the formula extremely robust? Many thanks, Peggy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Record entry by date | Excel Worksheet Functions | |||
| Formula that will record the time and date when an entry is made on a sheet | Excel Worksheet Functions | |||
| Date function to record changes within a row | Excel Worksheet Functions | |||
| How can I count a record if it contains a date within a date range | Excel Worksheet Functions | |||
| How can I record the date of last revision in footer? | Excel Worksheet Functions | |||
Threaded Mode
