Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If and a date
I have a formula that gives me the first day of the week that a
transaction took place. =K2-WEEKDAY(K2)+2 This works fine so long as there is a date in "K2" but if it is blank then i get a #Value. error I have tried using various "if" statements to say if K2 is blank then the destination cell should also be blank. But all of my "if" statements keep giving errors. (K2 is formatted as dd-mmm-yyyy if that makes a difference.) What is the best way to write this please. Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates - Need to display date one month prior to user-entered date | Excel Worksheet Functions | |||
how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |