Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 12-08-2010, 07:43 AM
Nirik's Avatar
Nirik Nirik is offline Today() Windows XP Today() Office 2007
Smart Novice
 
Join Date: Dec 2010
Location: Mumbai, India
Posts: 24
Nirik is on a distinguished road
Smile Date result

Instead of writing one formula u can write multiple formula and then concatenate it, so that the date won't get converted into number. The formula in COLOUMN F needs to be written first in accordance with the number mention and afterwards the main formula than u needed. Go through the sample attachment for reference.
Attached Files
File Type: xls date file.xls (17.0 KB, 16 views)
Reply With Quote
 

Tags
date, format, today



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to make the task starts next day if no time enough today(task can not be split) duraid Project 1 10-25-2010 08:31 AM
Creating an Auto-Calc'd Date? Today+7 Days? SoCalTelephone Word 0 10-06-2010 10:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft