| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to record the date
Hi everyone,
It seems to working now! Thanks for your help. Kind regards, Peggy "Niek Otten" wrote: Hi Peggy, This? =IF(MOD(B2,1)TIME(14,0,0),TODAY()+1, TODAY()) -- Kind regards, Niek Otten Microsoft MVP - Excel "Peggy" wrote in message ... | 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
