Sir,
good morning
In Sheet 1, Column contains date and i want to generate this date to sheet 2 .
While I am trying to generate date value to sheet 2 from sheet1 using formula ( = value $A1). If there is no date value in sheet 1 but in the sheet2 date value shows 1/0/1900. how can I keep blanket in each cells of sheet2 if there is no date value in sheet 1.
sample copy attached.
Very simple. Use this formula:
=IF(Sheet1!$A1="","",Sheet1!$A1)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks for your reply
But i am looking to generate date value for whole column ( A) . so that when i am entering date values in sheet1, its will help me to generate date value from sheet 1 to sheet 2
=IF(Sheet1!A1<>"",VALUE(Sheet1!$A1),"")
Or use the formula given by Ali, =IF(Sheet1!$A1="","",Sheet1!$A1)- you just need to change it to date format.
Originally Posted by fmoiduf
Yes - what's the problem? Copy the formula into A1 of sheet 2 and drag copy it down as far as you need.
Not so - it works fine as it is on the OP's sample sheet.you just need to change it to date format.
Thanks for your great support
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks